Returns a Boolean value indicating the type of locking that is in effect.
Syntax
object.LockEdits
The object placeholder represents an object expression that evaluates to an object in the Applies To list.
Return Values
The return values for LockEdits are:
| Setting | Description |
| True | Pessimistic locking is in effect. |
| False | (Default) Optimistic locking is in effect. |
Remarks
If a page is locked and the data source uses page locking, no other user can edit rows on the same page. If row-level locking is used, the row being edited and all other rows in the rowset are locked. The rowset is defined as the number of rows specified by the RowsetSize property. If LockEdits is True and another user already has the page locked, an error occurs when you use the OpenResultset method. Generally, other users can read data from locked pages.
If LockEdits is False (the default) and you later use Update while the page is locked by another user, an error occurs. To see the changes made to your row by another user (and lose your changes), set the Bookmark property of your rdoResultset object to itself.
Note Data page size is determined by the data source. Microsoft SQL Server uses 2K data pages.